﻿<?xml version="1.0" encoding="utf-8" ?>
<healthcheck>
  <name>CollectionInformation</name>
  <description>Collections</description>
  <returntype>simplegrid</returntype>
  <query>
    <name>Collection</name>
    <description>List of Collections</description>
    <namespace>site</namespace>
    <type>WQL</type>
    <queryID>1</queryID>
    <sql>
      SELECT * FROM SMS_Collection where CollectionID like '@@SITECODE@@%'
    </sql>
    <field name="CollectionID" description="ID" props="" queryID="1" bestfit="true" />
    <field name="Name" description="Name" props="" queryID="1" bestfit="true" />
    <field name="Comment" description="Comment" props="" queryID="1" bestfit="true" />
    <field name="CurrentStatus" description="Status" props="" queryID="1" bestfit="true" />
    <field name="LastChangeTime" description="Last Change Time" props="" queryID="1" bestfit="true" />
    <field name="LastMemberChangeTime" description="Last Member Change Time" props="" queryID="1" bestfit="true" />
    <field name="LastRefreshTime" description="Last Refresh Time" props="" queryID="1" bestfit="true" />
    <field name="RefreshType" description="Refresh Type" props="" queryID="1" bestfit="true" />
    <field name="ServiceWindowCount" description="Number of Maintenance Windows" props="" queryID="1" bestfit="true" />
  </query>
</healthcheck>